Configuration
Platform Settings
Specify the following parameters at the platform level:
| Parameter Name | Description | Acceptable Values | Default Value |
|---|---|---|---|
| Port | The port used to connect to the Azure MySQL instance | Integer | 3306 |
| ConnectionCommand | The ODBC connection string which will include the ODBC Driver and connection details | Yes, No | Driver={MySQL ODBC 8.0 Unicode Driver};SERVER=%ADDRESS%;PORT=%PORT%;DATABASE=%DATABASE%;UID=%USER%;PWD=%LOGONPASSWORD%; |
| ChangeCommand | The legal SQL statement template that will be used to change the password on the required database. | SQL Statement | alter user %USER% identified by '%NEWPASSWORD%'; |
| ReconcileCommand | The legal SQL statement template that will be used to reconcile the password on the required database. | SQL Statement | alter user %USER% identified by '%NEWPASSWORD%'; |
| Debug | To enable debug logs | Yes, No | No |
Note: The change command has changed in the latest version of MySQL (8.x). MySQL's documentation specifically points out that it's preference is that the command uses alter user rather than set password. Documentation can be referenced here - https://dev.mysql.com/doc/refman/8.0/en/set-password.html
Note: This is for Azure MySQL Flexible Server. Single server is being discontinued on September 16th, 2024. More can be found at the link below to Microsoft's documentation.
https://learn.microsoft.com/en-us/azure/mysql/single-server/whats-happening-to-mysql-single-server